UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqU66Rm8KvSkGqdPcqEeaf1/tzPh3QVT22hQvjiRXOc='
WHERE
key_id = 'd8990d6c347ca750988b07180f006b6d2fb0c6835ec6763102769975349bc5b2'
AND (
token = 'XqU66Rm8KvSkGqdPcqEeaf1/tzPh3QVT22hQvjiRXOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)