UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OFXb/G93mXAy7Fdt9qw7jU/pXTes1zdvzf2/ug1P7fk='
WHERE
key_id = '1196e46481a2154baab0c78bbb716a969098fb64679b60bf034f6372a56c6d31'
AND (
token = 'OFXb/G93mXAy7Fdt9qw7jU/pXTes1zdvzf2/ug1P7fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)