UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eFR/9VObi8a3NZnx2O6AuB8RRuF221b278l++YFz+Ow='
WHERE
key_id = 'a7e3ed77d36b9ef68ede7a8f0162fa10211e821688f4db4f714a5218c40fcd64'
AND (
token = 'eFR/9VObi8a3NZnx2O6AuB8RRuF221b278l++YFz+Ow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)