UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '07bT6+qzOg5E3rO8ONObAwQLnwqELtzC7TLJcy4PLQA='
WHERE
key_id = '0c5d660e1c45e81d014cec61bd15a53f71b881a53490af1e2ca532d1b177ee17'
AND (
token = '07bT6+qzOg5E3rO8ONObAwQLnwqELtzC7TLJcy4PLQA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)