UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVRQRCAkb3mm+yyzQLN8yry9Z4paopykxJMXZZclByw='
WHERE
key_id = '4e8c6ffb41b9899dfc8233f7cf5070de01affb95663a9abefe5f5aff9bc6853e'
AND (
token = 'pVRQRCAkb3mm+yyzQLN8yry9Z4paopykxJMXZZclByw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)