UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W9WbjxYKp4gESGTYFJh/owmgUgzbxtFAEGAD4kRM2pU='
WHERE
key_id = 'fc7ae7c1a75c45c7b88f3c4a84ec87ca2ad36e386904551be88fbbde9a756b49'
AND (
token = 'W9WbjxYKp4gESGTYFJh/owmgUgzbxtFAEGAD4kRM2pU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)