UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WZz+xTerXoMV3+XXdkEEmYy05yNuVBhvPR0HlOhaNPc='
WHERE
key_id = '747e103ee436cca43c02d08d62c4eee4f3e6a74d17554d9e460270b6d93906f3'
AND (
token = 'WZz+xTerXoMV3+XXdkEEmYy05yNuVBhvPR0HlOhaNPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)