UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm7ndmAW1IBJfPavFKcjGrqSJbscNiy5O5MmQQsKagW0='
WHERE
key_id = '6de6ddff2f8cb94c6967730eb44ff5dc10e645ce442970a1a0fae8a1aedfd367'
AND (
token = 'm7ndmAW1IBJfPavFKcjGrqSJbscNiy5O5MmQQsKagW0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)