UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zy4NwtFMhxh0Iq4gH/CU2pRUJ4LNs6gMQoSQC9EJe/E='
WHERE
key_id = 'c81627d47a57dabe3aaf9facf21c6039e6fd8d5e33476cc0275d7a7f7c42b7f8'
AND (
token = 'zy4NwtFMhxh0Iq4gH/CU2pRUJ4LNs6gMQoSQC9EJe/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)