UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's5EMHcWGEbIFj745Th5FBLFateoRpVeInVJHgjDaDGg='
WHERE
key_id = '397020ae2451c31a4dcdb4ac931f44ae51469903e0e7b5f9d2c5b6783ce716aa'
AND (
token = 's5EMHcWGEbIFj745Th5FBLFateoRpVeInVJHgjDaDGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)