UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHTmkbcR7VcYoagtRgyX5tGZjVQdk5LJYm4gJ3FG/HA='
WHERE
key_id = '8a44983581fd00822067063f800d583301a68f912c310823e2d7ce0ea730dbb1'
AND (
token = 'BHTmkbcR7VcYoagtRgyX5tGZjVQdk5LJYm4gJ3FG/HA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)