UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2fDvjHTzTwqHp59fLKhNCr3zQ1mjgOC32RmNpf1DHzo='
WHERE
key_id = '247bf7c33de7b07ea0a182b2f847cd496796d5c865cbe03054075c6064b371cb'
AND (
token = '2fDvjHTzTwqHp59fLKhNCr3zQ1mjgOC32RmNpf1DHzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)