UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ilhAX4XlM3WcmuCPDcWJgPJ0kVDcJHSVHyK/KVQPIo='
WHERE
key_id = '06ebba60b0dce64c1fcdb9c00e25dbdd283638459c806d6fe780eaf4f2e12274'
AND (
token = '8ilhAX4XlM3WcmuCPDcWJgPJ0kVDcJHSVHyK/KVQPIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)