UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p/mBqqJW06VkXCnH+NCJ0WRCCveYS56KNDj9ETDXNKE='
WHERE
key_id = '2547b490182b64be3926e33ffa18e2383a3259e3b740823a485bdb5325232daf'
AND (
token = 'p/mBqqJW06VkXCnH+NCJ0WRCCveYS56KNDj9ETDXNKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)