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