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