UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bUMxNPD5c5US5lCXzXwAaQhd5tWBD76TuKfe5S4elqE='
WHERE
key_id = 'ae004ba19fe392f5b8a3cb863673a771ade2c779fa015f4ee3772fe848853cea'
AND (
token = 'bUMxNPD5c5US5lCXzXwAaQhd5tWBD76TuKfe5S4elqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)