UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YfNpf02xg3Qnf7aWqrk7f39vogebOrmkFJSeiQlc+B4='
WHERE
key_id = '199415e76d1d36c06f8231c54480379acf54ef82528ea443a52e97c13a5aaaf4'
AND (
token = 'YfNpf02xg3Qnf7aWqrk7f39vogebOrmkFJSeiQlc+B4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)