UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgbDg4JdU8P8spfX1ISLLTQ6A526r9jNY/2n43+Rghs='
WHERE
key_id = '7cde870de4124ff25183631fd9aa015e85aa248059a00de9652e6f455b946112'
AND (
token = 'CgbDg4JdU8P8spfX1ISLLTQ6A526r9jNY/2n43+Rghs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)