UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zWsELPfqNYNpqtIz5VFx57sKtTJ3wsi1hy0J/Tj2nus='
WHERE
key_id = 'c0e4a9b8bc537dd0637cfc1ca0170d0a70fb52dd2c1914c6059ad96c4c517033'
AND (
token = 'zWsELPfqNYNpqtIz5VFx57sKtTJ3wsi1hy0J/Tj2nus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)