UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0yWpat5C+uSgmv02hzGNZR0R4MM/BMqlAeohZNZ/+3w='
WHERE
key_id = '8b01c2710b4097b9b0dd547f00e38dee87617541327931c5cfcd7f26f6269346'
AND (
token = '0yWpat5C+uSgmv02hzGNZR0R4MM/BMqlAeohZNZ/+3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)