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