UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iHXmKcKQweTT2wGHh/ICtUjUecqyubSXmoqYPU3qRoc='
WHERE
key_id = 'd41baddb518d2a89c2b16b561cde0d7aee572712163af3c31639eed33ec35301'
AND (
token = 'iHXmKcKQweTT2wGHh/ICtUjUecqyubSXmoqYPU3qRoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)