UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fqG8o1r7GM0BX6GGq3FOm8qap0hyh9Lybnwo30yZktM='
WHERE
key_id = '71d714acf27e6c2ba4507d79e53ff341ea6e9b7d9300cde0a749ba8b1b65d512'
AND (
token = 'fqG8o1r7GM0BX6GGq3FOm8qap0hyh9Lybnwo30yZktM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)