UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hasQqifW7FSRKuSi+qcJdRdRcyorMdmyl8I+WQK5Tes='
WHERE
key_id = 'a67fcc59f0d6a067788747a73c6926115c7115dc190d9a0e30a02777dd473bf9'
AND (
token = 'hasQqifW7FSRKuSi+qcJdRdRcyorMdmyl8I+WQK5Tes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)