UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l/5Tj6cM/IdLQblu/aqYHHppj5rhKYTJtlOG6HtGvko='
WHERE
key_id = 'c29d3500252cd04abf0820c7dd11c41bd823219c4fe365039330b25c343e3c50'
AND (
token = 'l/5Tj6cM/IdLQblu/aqYHHppj5rhKYTJtlOG6HtGvko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)