UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TlhPLHcoXkHjofzOBtUUehm8Nz3UuCfNc+5GoZooaDg='
WHERE
key_id = 'b48e236de6b55588a353d944df0892e5253efae9297d2c174a669355443a8966'
AND (
token = 'TlhPLHcoXkHjofzOBtUUehm8Nz3UuCfNc+5GoZooaDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)